ALTER TABLE [CarModel] NOCHECK CONSTRAINT ALL
GO

SET IDENTITY_INSERT [CarModel] ON 
PRINT 'Begin inserting data in CarModel'
SET IDENTITY_INSERT [CarModel] OFF 
ALTER TABLE [CarModel] CHECK CONSTRAINT ALL
GO



ALTER TABLE [Country] NOCHECK CONSTRAINT ALL
GO

SET IDENTITY_INSERT [Country] ON 
PRINT 'Begin inserting data in Country'
INSERT INTO [Country] ([Id], [EnglishName], [LocalName], [CountryCode])
VALUES(305, 'Afghanistan', NULL, 'AFG')
INSERT INTO [Country] ([Id], [EnglishName], [LocalName], [CountryCode])
VALUES(307, 'Albania', NULL, 'ALB')
INSERT INTO [Country] ([Id], [EnglishName], [LocalName], [CountryCode])
VALUES(308, 'Algeria', NULL, 'DZA')
INSERT INTO [Country] ([Id], [EnglishName], [LocalName], [CountryCode])
VALUES(309, 'American Samoa', NULL, 'ASM')
INSERT INTO [Country] ([Id], [EnglishName], [LocalName], [CountryCode])
VALUES(310, 'Andorra', NULL, 'AND')
INSERT INTO [Country] ([Id], [EnglishName], [LocalName], [CountryCode])
VALUES(311, 'Angola', NULL, 'AGO')
INSERT INTO [Country] ([Id], [EnglishName], [LocalName], [CountryCode])
VALUES(312, 'Anguilla', NULL, 'AIA')
INSERT INTO [Country] ([Id], [EnglishName], [LocalName], [CountryCode])
VALUES(313, 'Antigua and Barbuda', NULL, 'ATG')
INSERT INTO [Country] ([Id], [EnglishName], [LocalName], [CountryCode])
VALUES(314, 'Argentina', NULL, 'ARG')
INSERT INTO [Country] ([Id], [EnglishName], [LocalName], [CountryCode])
VALUES(315, 'Armenia', NULL, 'ARM')
INSERT INTO [Country] ([Id], [EnglishName], [LocalName], [CountryCode])
VALUES(316, 'Aruba', NULL, 'ABW')
INSERT INTO [Country] ([Id], [EnglishName], [LocalName], [CountryCode])
VALUES(317, 'Australia', NULL, 'AUS')
INSERT INTO [Country] ([Id], [EnglishName], [LocalName], [CountryCode])
VALUES(318, 'Austria', NULL, 'AUT')
INSERT INTO [Country] ([Id], [EnglishName], [LocalName], [CountryCode])
VALUES(319, 'Azerbaijan', NULL, 'AZE')
INSERT INTO [Country] ([Id], [EnglishName], [LocalName], [CountryCode])
VALUES(320, 'Bahamas', NULL, 'BHS')
INSERT INTO [Country] ([Id], [EnglishName], [LocalName], [CountryCode])
VALUES(321, 'Bahrain', NULL, 'BHR')
INSERT INTO [Country] ([Id], [EnglishName], [LocalName], [CountryCode])
VALUES(322, 'Bangladesh', NULL, 'BGD')
INSERT INTO [Country] ([Id], [EnglishName], [LocalName], [CountryCode])
VALUES(323, 'Barbados', NULL, 'BRB')
INSERT INTO [Country] ([Id], [EnglishName], [LocalName], [CountryCode])
VALUES(324, 'Belarus', NULL, 'BLR')
INSERT INTO [Country] ([Id], [EnglishName], [LocalName], [CountryCode])
VALUES(325, 'Belgium', NULL, 'BEL')
INSERT INTO [Country] ([Id], [EnglishName], [LocalName], [CountryCode])
VALUES(326, 'Belize', NULL, 'BLZ')
INSERT INTO [Country] ([Id], [EnglishName], [LocalName], [CountryCode])
VALUES(327, 'Benin', NULL, 'BEN')
INSERT INTO [Country] ([Id], [EnglishName], [LocalName], [CountryCode])
VALUES(328, 'Bermuda', NULL, 'BMU')
INSERT INTO [Country] ([Id], [EnglishName], [LocalName], [CountryCode])
VALUES(329, 'Bhutan', NULL, 'BTN')
INSERT INTO [Country] ([Id], [EnglishName], [LocalName], [CountryCode])
VALUES(330, 'Bolivia', NULL, 'BOL')
INSERT INTO [Country] ([Id], [EnglishName], [LocalName], [CountryCode])
VALUES(331, 'Bosnia and Herzegovina', NULL, 'BIH')
INSERT INTO [Country] ([Id], [EnglishName], [LocalName], [CountryCode])
VALUES(332, 'Botswana', NULL, 'BWA')
INSERT INTO [Country] ([Id], [EnglishName], [LocalName], [CountryCode])
VALUES(333, 'Brazil', NULL, 'BRA')
INSERT INTO [Country] ([Id], [EnglishName], [LocalName], [CountryCode])
VALUES(334, 'British Virgin Islands', NULL, 'VGB')
INSERT INTO [Country] ([Id], [EnglishName], [LocalName], [CountryCode])
VALUES(335, 'Brunei Darussalam', NULL, 'BRN')
INSERT INTO [Country] ([Id], [EnglishName], [LocalName], [CountryCode])
VALUES(336, 'Bulgaria', NULL, 'BGR')
INSERT INTO [Country] ([Id], [EnglishName], [LocalName], [CountryCode])
VALUES(337, 'Burkina Faso', NULL, 'BFA')
INSERT INTO [Country] ([Id], [EnglishName], [LocalName], [CountryCode])
VALUES(338, 'Burundi', NULL, 'BDI')
INSERT INTO [Country] ([Id], [EnglishName], [LocalName], [CountryCode])
VALUES(339, 'Cambodia', NULL, 'KHM')
INSERT INTO [Country] ([Id], [EnglishName], [LocalName], [CountryCode])
VALUES(340, 'Cameroon', NULL, 'CMR')
INSERT INTO [Country] ([Id], [EnglishName], [LocalName], [CountryCode])
VALUES(341, 'Canada', NULL, 'CAN')
INSERT INTO [Country] ([Id], [EnglishName], [LocalName], [CountryCode])
VALUES(342, 'Cape Verde', NULL, 'CPV')
INSERT INTO [Country] ([Id], [EnglishName], [LocalName], [CountryCode])
VALUES(343, 'Cayman Islands', NULL, 'CYM')
INSERT INTO [Country] ([Id], [EnglishName], [LocalName], [CountryCode])
VALUES(344, 'Central African Republic', NULL, 'CAF')
INSERT INTO [Country] ([Id], [EnglishName], [LocalName], [CountryCode])
VALUES(345, 'Chad', NULL, 'TCD')
INSERT INTO [Country] ([Id], [EnglishName], [LocalName], [CountryCode])
VALUES(346, 'Chile', NULL, 'CHL')
INSERT INTO [Country] ([Id], [EnglishName], [LocalName], [CountryCode])
VALUES(347, 'China', NULL, 'CHN')
INSERT INTO [Country] ([Id], [EnglishName], [LocalName], [CountryCode])
VALUES(348, 'Colombia', NULL, 'COL')
INSERT INTO [Country] ([Id], [EnglishName], [LocalName], [CountryCode])
VALUES(349, 'Comoros', NULL, 'COM')
INSERT INTO [Country] ([Id], [EnglishName], [LocalName], [CountryCode])
VALUES(350, 'Congo, Republic of', NULL, 'COG')
INSERT INTO [Country] ([Id], [EnglishName], [LocalName], [CountryCode])
VALUES(351, 'Congo, Democratic Republic of', NULL, 'COD')
INSERT INTO [Country] ([Id], [EnglishName], [LocalName], [CountryCode])
VALUES(352, 'Cook Islands', NULL, 'COK')
INSERT INTO [Country] ([Id], [EnglishName], [LocalName], [CountryCode])
VALUES(353, 'Costa Rica', NULL, 'CRI')
INSERT INTO [Country] ([Id], [EnglishName], [LocalName], [CountryCode])
VALUES(354, 'Cote d''Ivoire', NULL, 'CIV')
INSERT INTO [Country] ([Id], [EnglishName], [LocalName], [CountryCode])
VALUES(355, 'Croatia', NULL, 'HRV')
INSERT INTO [Country] ([Id], [EnglishName], [LocalName], [CountryCode])
VALUES(356, 'Cuba', NULL, 'CUB')
INSERT INTO [Country] ([Id], [EnglishName], [LocalName], [CountryCode])
VALUES(357, 'Cyprus', NULL, 'CYP')
INSERT INTO [Country] ([Id], [EnglishName], [LocalName], [CountryCode])
VALUES(358, 'Czech Republic', NULL, 'CZE')
INSERT INTO [Country] ([Id], [EnglishName], [LocalName], [CountryCode])
VALUES(359, 'Denmark', NULL, 'DNK')
INSERT INTO [Country] ([Id], [EnglishName], [LocalName], [CountryCode])
VALUES(360, 'Djibouti', NULL, 'DJI')
INSERT INTO [Country] ([Id], [EnglishName], [LocalName], [CountryCode])
VALUES(361, 'Dominica', NULL, 'DMA')
INSERT INTO [Country] ([Id], [EnglishName], [LocalName], [CountryCode])
VALUES(362, 'Dominican Republic', NULL, 'DOM')
INSERT INTO [Country] ([Id], [EnglishName], [LocalName], [CountryCode])
VALUES(363, 'Ecuador', NULL, 'ECU')
INSERT INTO [Country] ([Id], [EnglishName], [LocalName], [CountryCode])
VALUES(364, 'Egypt', NULL, 'EGY')
INSERT INTO [Country] ([Id], [EnglishName], [LocalName], [CountryCode])
VALUES(365, 'El Salvador', NULL, 'SLV')
INSERT INTO [Country] ([Id], [EnglishName], [LocalName], [CountryCode])
VALUES(366, 'Equatorial Guinea', NULL, 'GNQ')
INSERT INTO [Country] ([Id], [EnglishName], [LocalName], [CountryCode])
VALUES(367, 'Eritrea', NULL, 'ERI')
INSERT INTO [Country] ([Id], [EnglishName], [LocalName], [CountryCode])
VALUES(368, 'Estonia', NULL, 'EST')
INSERT INTO [Country] ([Id], [EnglishName], [LocalName], [CountryCode])
VALUES(369, 'Ethiopia', NULL, 'ETH')
INSERT INTO [Country] ([Id], [EnglishName], [LocalName], [CountryCode])
VALUES(370, 'Falkland Islands (Malvinas)', NULL, 'FLK')
INSERT INTO [Country] ([Id], [EnglishName], [LocalName], [CountryCode])
VALUES(371, 'Faroe Islands', NULL, 'FRO')
INSERT INTO [Country] ([Id], [EnglishName], [LocalName], [CountryCode])
VALUES(372, 'Fiji', NULL, 'FJI')
INSERT INTO [Country] ([Id], [EnglishName], [LocalName], [CountryCode])
VALUES(373, 'Finland', NULL, 'FIN')
INSERT INTO [Country] ([Id], [EnglishName], [LocalName], [CountryCode])
VALUES(374, 'France', NULL, 'FRA')
INSERT INTO [Country] ([Id], [EnglishName], [LocalName], [CountryCode])
VALUES(375, 'French Guiana', NULL, 'GUF')
INSERT INTO [Country] ([Id], [EnglishName], [LocalName], [CountryCode])
VALUES(376, 'French Polynesia', NULL, 'PYF')
INSERT INTO [Country] ([Id], [EnglishName], [LocalName], [CountryCode])
VALUES(377, 'Gabon', NULL, 'GAB')
INSERT INTO [Country] ([Id], [EnglishName], [LocalName], [CountryCode])
VALUES(378, 'Gambia', NULL, 'GMB')
INSERT INTO [Country] ([Id], [EnglishName], [LocalName], [CountryCode])
VALUES(379, 'Georgia', NULL, 'GEO')
INSERT INTO [Country] ([Id], [EnglishName], [LocalName], [CountryCode])
VALUES(380, 'Germany', NULL, 'DEU')
INSERT INTO [Country] ([Id], [EnglishName], [LocalName], [CountryCode])
VALUES(381, 'Ghana', NULL, 'GHA')
INSERT INTO [Country] ([Id], [EnglishName], [LocalName], [CountryCode])
VALUES(382, 'Gibraltar', NULL, 'GIB')
INSERT INTO [Country] ([Id], [EnglishName], [LocalName], [CountryCode])
VALUES(383, 'Greece', NULL, 'GRC')
INSERT INTO [Country] ([Id], [EnglishName], [LocalName], [CountryCode])
VALUES(384, 'Greenland', NULL, 'GRL')
INSERT INTO [Country] ([Id], [EnglishName], [LocalName], [CountryCode])
VALUES(385, 'Grenada', NULL, 'GRD')
INSERT INTO [Country] ([Id], [EnglishName], [LocalName], [CountryCode])
VALUES(386, 'Guadeloupe', NULL, 'GLP')
INSERT INTO [Country] ([Id], [EnglishName], [LocalName], [CountryCode])
VALUES(387, 'Guam', NULL, 'GUM')
INSERT INTO [Country] ([Id], [EnglishName], [LocalName], [CountryCode])
VALUES(388, 'Guatemala', NULL, 'GTM')
INSERT INTO [Country] ([Id], [EnglishName], [LocalName], [CountryCode])
VALUES(389, 'Guernsey', NULL, 'GGY')
INSERT INTO [Country] ([Id], [EnglishName], [LocalName], [CountryCode])
VALUES(390, 'Guinea', NULL, 'GIN')
INSERT INTO [Country] ([Id], [EnglishName], [LocalName], [CountryCode])
VALUES(391, 'Guinea-Bissau', NULL, 'GNB')
INSERT INTO [Country] ([Id], [EnglishName], [LocalName], [CountryCode])
VALUES(392, 'Guyana', NULL, 'GUY')
INSERT INTO [Country] ([Id], [EnglishName], [LocalName], [CountryCode])
VALUES(393, 'Haiti', NULL, 'HTI')
INSERT INTO [Country] ([Id], [EnglishName], [LocalName], [CountryCode])
VALUES(394, 'Honduras', NULL, 'HND')
INSERT INTO [Country] ([Id], [EnglishName], [LocalName], [CountryCode])
VALUES(395, 'Hong Kong', NULL, 'HKG')
INSERT INTO [Country] ([Id], [EnglishName], [LocalName], [CountryCode])
VALUES(396, 'Hungary', NULL, 'HUN')
INSERT INTO [Country] ([Id], [EnglishName], [LocalName], [CountryCode])
VALUES(397, 'Iceland', NULL, 'ISL')
INSERT INTO [Country] ([Id], [EnglishName], [LocalName], [CountryCode])
VALUES(398, 'India', NULL, 'IND')
INSERT INTO [Country] ([Id], [EnglishName], [LocalName], [CountryCode])
VALUES(399, 'Indonesia', NULL, 'IDN')
INSERT INTO [Country] ([Id], [EnglishName], [LocalName], [CountryCode])
VALUES(400, 'Iran', NULL, 'IRN')
INSERT INTO [Country] ([Id], [EnglishName], [LocalName], [CountryCode])
VALUES(401, 'Iraq', NULL, 'IRQ')
INSERT INTO [Country] ([Id], [EnglishName], [LocalName], [CountryCode])
VALUES(402, 'Ireland', NULL, 'IRL')
INSERT INTO [Country] ([Id], [EnglishName], [LocalName], [CountryCode])
VALUES(403, 'Isle of Man', NULL, 'IMN')
INSERT INTO [Country] ([Id], [EnglishName], [LocalName], [CountryCode])
VALUES(404, 'Israel', NULL, 'ISR')
INSERT INTO [Country] ([Id], [EnglishName], [LocalName], [CountryCode])
VALUES(405, 'Italy', NULL, 'ITA')
INSERT INTO [Country] ([Id], [EnglishName], [LocalName], [CountryCode])
VALUES(406, 'Jamaica', NULL, 'JAM')
INSERT INTO [Country] ([Id], [EnglishName], [LocalName], [CountryCode])
VALUES(407, 'Japan', NULL, 'JPN')
INSERT INTO [Country] ([Id], [EnglishName], [LocalName], [CountryCode])
VALUES(408, 'Jersey', NULL, 'JEY')
INSERT INTO [Country] ([Id], [EnglishName], [LocalName], [CountryCode])
VALUES(409, 'Jordan', NULL, 'JOR')
INSERT INTO [Country] ([Id], [EnglishName], [LocalName], [CountryCode])
VALUES(410, 'Kazakhstan', NULL, 'KAZ')
INSERT INTO [Country] ([Id], [EnglishName], [LocalName], [CountryCode])
VALUES(411, 'Kenya', NULL, 'KEN')
INSERT INTO [Country] ([Id], [EnglishName], [LocalName], [CountryCode])
VALUES(412, 'Kiribati', NULL, 'KIR')
INSERT INTO [Country] ([Id], [EnglishName], [LocalName], [CountryCode])
VALUES(413, 'Korea, North', NULL, 'PRK')
INSERT INTO [Country] ([Id], [EnglishName], [LocalName], [CountryCode])
VALUES(414, 'Korea, South', NULL, 'KOR')
INSERT INTO [Country] ([Id], [EnglishName], [LocalName], [CountryCode])
VALUES(415, 'Kuwait', NULL, 'KWT')
INSERT INTO [Country] ([Id], [EnglishName], [LocalName], [CountryCode])
VALUES(416, 'Kyrgyzstan', NULL, 'KGZ')
INSERT INTO [Country] ([Id], [EnglishName], [LocalName], [CountryCode])
VALUES(417, 'Laos', NULL, 'LAO')
INSERT INTO [Country] ([Id], [EnglishName], [LocalName], [CountryCode])
VALUES(418, 'Latvia', NULL, 'LVA')
INSERT INTO [Country] ([Id], [EnglishName], [LocalName], [CountryCode])
VALUES(419, 'Lebanon', NULL, 'LBN')
INSERT INTO [Country] ([Id], [EnglishName], [LocalName], [CountryCode])
VALUES(420, 'Lesotho', NULL, 'LSO')
INSERT INTO [Country] ([Id], [EnglishName], [LocalName], [CountryCode])
VALUES(421, 'Liberia', NULL, 'LBR')
INSERT INTO [Country] ([Id], [EnglishName], [LocalName], [CountryCode])
VALUES(422, 'Libya', NULL, 'LBY')
INSERT INTO [Country] ([Id], [EnglishName], [LocalName], [CountryCode])
VALUES(423, 'Liechtenstein', NULL, 'LIE')
INSERT INTO [Country] ([Id], [EnglishName], [LocalName], [CountryCode])
VALUES(424, 'Lithuania', NULL, 'LTU')
INSERT INTO [Country] ([Id], [EnglishName], [LocalName], [CountryCode])
VALUES(425, 'Luxembourg', NULL, 'LUX')
INSERT INTO [Country] ([Id], [EnglishName], [LocalName], [CountryCode])
VALUES(426, 'Macau', NULL, 'MAC')
INSERT INTO [Country] ([Id], [EnglishName], [LocalName], [CountryCode])
VALUES(427, 'Macedonia', NULL, 'MKD')
INSERT INTO [Country] ([Id], [EnglishName], [LocalName], [CountryCode])
VALUES(428, 'Madagascar', NULL, 'MDG')
INSERT INTO [Country] ([Id], [EnglishName], [LocalName], [CountryCode])
VALUES(429, 'Malawi', NULL, 'MWI')
INSERT INTO [Country] ([Id], [EnglishName], [LocalName], [CountryCode])
VALUES(430, 'Malaysia', NULL, 'MYS')
INSERT INTO [Country] ([Id], [EnglishName], [LocalName], [CountryCode])
VALUES(431, 'Maldives', NULL, 'MDV')
INSERT INTO [Country] ([Id], [EnglishName], [LocalName], [CountryCode])
VALUES(432, 'Mali', NULL, 'MLI')
INSERT INTO [Country] ([Id], [EnglishName], [LocalName], [CountryCode])
VALUES(433, 'Malta', NULL, 'MLT')
INSERT INTO [Country] ([Id], [EnglishName], [LocalName], [CountryCode])
VALUES(434, 'Marshall Islands', NULL, 'MHL')
INSERT INTO [Country] ([Id], [EnglishName], [LocalName], [CountryCode])
VALUES(435, 'Martinique', NULL, 'MTQ')
INSERT INTO [Country] ([Id], [EnglishName], [LocalName], [CountryCode])
VALUES(436, 'Mauritania', NULL, 'MRT')
INSERT INTO [Country] ([Id], [EnglishName], [LocalName], [CountryCode])
VALUES(437, 'Mauritius', NULL, 'MUS')
INSERT INTO [Country] ([Id], [EnglishName], [LocalName], [CountryCode])
VALUES(438, 'Mayotte', NULL, 'MYT')
INSERT INTO [Country] ([Id], [EnglishName], [LocalName], [CountryCode])
VALUES(439, 'Mexico', NULL, 'MEX')
INSERT INTO [Country] ([Id], [EnglishName], [LocalName], [CountryCode])
VALUES(440, 'Micronesia', NULL, 'FSM')
INSERT INTO [Country] ([Id], [EnglishName], [LocalName], [CountryCode])
VALUES(441, 'Moldova', NULL, 'MDA')
INSERT INTO [Country] ([Id], [EnglishName], [LocalName], [CountryCode])
VALUES(442, 'Monaco', NULL, 'MCO')
INSERT INTO [Country] ([Id], [EnglishName], [LocalName], [CountryCode])
VALUES(443, 'Mongolia', NULL, 'MNG')
INSERT INTO [Country] ([Id], [EnglishName], [LocalName], [CountryCode])
VALUES(444, 'Montenegro', NULL, '   ')
INSERT INTO [Country] ([Id], [EnglishName], [LocalName], [CountryCode])
VALUES(445, 'Montserrat', NULL, 'MSR')
INSERT INTO [Country] ([Id], [EnglishName], [LocalName], [CountryCode])
VALUES(446, 'Morocco', NULL, 'MAR')
INSERT INTO [Country] ([Id], [EnglishName], [LocalName], [CountryCode])
VALUES(447, 'Mozambique', NULL, 'MOZ')
INSERT INTO [Country] ([Id], [EnglishName], [LocalName], [CountryCode])
VALUES(448, 'Myanmar', NULL, 'MMR')
INSERT INTO [Country] ([Id], [EnglishName], [LocalName], [CountryCode])
VALUES(449, 'Namibia', NULL, 'NAM')
INSERT INTO [Country] ([Id], [EnglishName], [LocalName], [CountryCode])
VALUES(450, 'Nauru', NULL, 'NRU')
INSERT INTO [Country] ([Id], [EnglishName], [LocalName], [CountryCode])
VALUES(451, 'Nepal', NULL, 'NPL')
INSERT INTO [Country] ([Id], [EnglishName], [LocalName], [CountryCode])
VALUES(452, 'Netherlands', NULL, 'NLD')
INSERT INTO [Country] ([Id], [EnglishName], [LocalName], [CountryCode])
VALUES(453, 'Netherlands Antilles', NULL, 'ANT')
INSERT INTO [Country] ([Id], [EnglishName], [LocalName], [CountryCode])
VALUES(454, 'New Caledonia', NULL, 'NCL')
INSERT INTO [Country] ([Id], [EnglishName], [LocalName], [CountryCode])
VALUES(455, 'New Zealand', NULL, 'NZL')
INSERT INTO [Country] ([Id], [EnglishName], [LocalName], [CountryCode])
VALUES(456, 'Nicaragua', NULL, 'NIC')
INSERT INTO [Country] ([Id], [EnglishName], [LocalName], [CountryCode])
VALUES(457, 'Niue', NULL, 'NIU')
INSERT INTO [Country] ([Id], [EnglishName], [LocalName], [CountryCode])
VALUES(458, 'Niger', NULL, 'NER')
INSERT INTO [Country] ([Id], [EnglishName], [LocalName], [CountryCode])
VALUES(459, 'Nigeria', NULL, 'NGA')
INSERT INTO [Country] ([Id], [EnglishName], [LocalName], [CountryCode])
VALUES(460, 'Norfolk Island', NULL, 'NFK')
INSERT INTO [Country] ([Id], [EnglishName], [LocalName], [CountryCode])
VALUES(461, 'Northern Mariana Islands', NULL, 'MNP')
INSERT INTO [Country] ([Id], [EnglishName], [LocalName], [CountryCode])
VALUES(462, 'Norway', NULL, 'NOR')
INSERT INTO [Country] ([Id], [EnglishName], [LocalName], [CountryCode])
VALUES(463, 'Oman', NULL, 'OMN')
INSERT INTO [Country] ([Id], [EnglishName], [LocalName], [CountryCode])
VALUES(464, 'Pakistan', NULL, 'PAK')
INSERT INTO [Country] ([Id], [EnglishName], [LocalName], [CountryCode])
VALUES(465, 'Palau', NULL, 'PLW')
INSERT INTO [Country] ([Id], [EnglishName], [LocalName], [CountryCode])
VALUES(466, 'Palestinian Territory, Occupied', NULL, 'PSE')
INSERT INTO [Country] ([Id], [EnglishName], [LocalName], [CountryCode])
VALUES(467, 'Panama', NULL, 'PAN')
INSERT INTO [Country] ([Id], [EnglishName], [LocalName], [CountryCode])
VALUES(468, 'Papua New Guinea', NULL, 'PNG')
INSERT INTO [Country] ([Id], [EnglishName], [LocalName], [CountryCode])
VALUES(469, 'Paraguay', NULL, 'PRY')
INSERT INTO [Country] ([Id], [EnglishName], [LocalName], [CountryCode])
VALUES(470, 'Peru', NULL, 'PER')
INSERT INTO [Country] ([Id], [EnglishName], [LocalName], [CountryCode])
VALUES(471, 'Philippines', NULL, 'PHL')
INSERT INTO [Country] ([Id], [EnglishName], [LocalName], [CountryCode])
VALUES(472, 'Pitcairn Island', NULL, 'PCN')
INSERT INTO [Country] ([Id], [EnglishName], [LocalName], [CountryCode])
VALUES(473, 'Poland', NULL, 'POL')
INSERT INTO [Country] ([Id], [EnglishName], [LocalName], [CountryCode])
VALUES(474, 'Portugal', NULL, 'PRT')
INSERT INTO [Country] ([Id], [EnglishName], [LocalName], [CountryCode])
VALUES(475, 'Puerto Rico', NULL, 'PRI')
INSERT INTO [Country] ([Id], [EnglishName], [LocalName], [CountryCode])
VALUES(476, 'Qatar', NULL, 'QAT')
INSERT INTO [Country] ([Id], [EnglishName], [LocalName], [CountryCode])
VALUES(477, 'Reunion', NULL, 'REU')
INSERT INTO [Country] ([Id], [EnglishName], [LocalName], [CountryCode])
VALUES(478, 'Romania', NULL, 'ROU')
INSERT INTO [Country] ([Id], [EnglishName], [LocalName], [CountryCode])
VALUES(479, 'Russia', NULL, 'RUS')
INSERT INTO [Country] ([Id], [EnglishName], [LocalName], [CountryCode])
VALUES(480, 'Rwanda', NULL, 'RWA')
INSERT INTO [Country] ([Id], [EnglishName], [LocalName], [CountryCode])
VALUES(481, 'Saint Barthelemy', NULL, 'BLM')
INSERT INTO [Country] ([Id], [EnglishName], [LocalName], [CountryCode])
VALUES(482, 'Saint Helena', NULL, 'SHN')
INSERT INTO [Country] ([Id], [EnglishName], [LocalName], [CountryCode])
VALUES(483, 'Saint Kitts and Nevis', NULL, 'KNA')
INSERT INTO [Country] ([Id], [EnglishName], [LocalName], [CountryCode])
VALUES(484, 'Saint Lucia', NULL, 'LCA')
INSERT INTO [Country] ([Id], [EnglishName], [LocalName], [CountryCode])
VALUES(485, 'Saint Martin', NULL, 'MAF')
INSERT INTO [Country] ([Id], [EnglishName], [LocalName], [CountryCode])
VALUES(486, 'Saint Pierre and Miquelon', NULL, 'SPM')
INSERT INTO [Country] ([Id], [EnglishName], [LocalName], [CountryCode])
VALUES(487, 'Saint Vincent and the Grenadines', NULL, 'VCT')
INSERT INTO [Country] ([Id], [EnglishName], [LocalName], [CountryCode])
VALUES(488, 'Samoa', NULL, 'WSM')
INSERT INTO [Country] ([Id], [EnglishName], [LocalName], [CountryCode])
VALUES(489, 'San Marino', NULL, 'SMR')
INSERT INTO [Country] ([Id], [EnglishName], [LocalName], [CountryCode])
VALUES(490, 'Sao Tome and Principe', NULL, 'STP')
INSERT INTO [Country] ([Id], [EnglishName], [LocalName], [CountryCode])
VALUES(491, 'Saudia Arabia', NULL, 'SAU')
INSERT INTO [Country] ([Id], [EnglishName], [LocalName], [CountryCode])
VALUES(492, 'Senegal', NULL, 'SEN')
INSERT INTO [Country] ([Id], [EnglishName], [LocalName], [CountryCode])
VALUES(493, 'Serbia', NULL, 'SCG')
INSERT INTO [Country] ([Id], [EnglishName], [LocalName], [CountryCode])
VALUES(494, 'Seychelles', NULL, 'SYC')
INSERT INTO [Country] ([Id], [EnglishName], [LocalName], [CountryCode])
VALUES(495, 'Sierra Leone', NULL, 'SLE')
INSERT INTO [Country] ([Id], [EnglishName], [LocalName], [CountryCode])
VALUES(496, 'Singapore', NULL, 'SGP')
INSERT INTO [Country] ([Id], [EnglishName], [LocalName], [CountryCode])
VALUES(497, 'Slovakia', NULL, 'SVK')
INSERT INTO [Country] ([Id], [EnglishName], [LocalName], [CountryCode])
VALUES(498, 'Slovenia', NULL, 'SVN')
INSERT INTO [Country] ([Id], [EnglishName], [LocalName], [CountryCode])
VALUES(499, 'Solomon Islands', NULL, 'SLB')
INSERT INTO [Country] ([Id], [EnglishName], [LocalName], [CountryCode])
VALUES(500, 'Somalia', NULL, 'SOM')
INSERT INTO [Country] ([Id], [EnglishName], [LocalName], [CountryCode])
VALUES(501, 'South Africa', NULL, 'ZAF')
INSERT INTO [Country] ([Id], [EnglishName], [LocalName], [CountryCode])
VALUES(502, 'Spain', NULL, 'ESP')
INSERT INTO [Country] ([Id], [EnglishName], [LocalName], [CountryCode])
VALUES(503, 'Sri Lanka', NULL, 'LKA')
INSERT INTO [Country] ([Id], [EnglishName], [LocalName], [CountryCode])
VALUES(504, 'Sudan', NULL, 'SDN')
INSERT INTO [Country] ([Id], [EnglishName], [LocalName], [CountryCode])
VALUES(505, 'Suriname', NULL, 'SUR')
INSERT INTO [Country] ([Id], [EnglishName], [LocalName], [CountryCode])
VALUES(506, 'Svalbard and Jan Mayen Islands', NULL, 'SJM')
INSERT INTO [Country] ([Id], [EnglishName], [LocalName], [CountryCode])
VALUES(507, 'Swaziland', NULL, 'SWZ')
INSERT INTO [Country] ([Id], [EnglishName], [LocalName], [CountryCode])
VALUES(508, 'Sweden', NULL, 'SWE')
INSERT INTO [Country] ([Id], [EnglishName], [LocalName], [CountryCode])
VALUES(509, 'Switzerland', NULL, 'CHE')
INSERT INTO [Country] ([Id], [EnglishName], [LocalName], [CountryCode])
VALUES(510, 'Syria', NULL, 'SYR')
INSERT INTO [Country] ([Id], [EnglishName], [LocalName], [CountryCode])
VALUES(511, 'Taiwan', NULL, 'TWN')
INSERT INTO [Country] ([Id], [EnglishName], [LocalName], [CountryCode])
VALUES(512, 'Tajikistan', NULL, 'TJK')
INSERT INTO [Country] ([Id], [EnglishName], [LocalName], [CountryCode])
VALUES(513, 'Tanzania', NULL, 'TZA')
INSERT INTO [Country] ([Id], [EnglishName], [LocalName], [CountryCode])
VALUES(514, 'Thailand', NULL, 'THA')
INSERT INTO [Country] ([Id], [EnglishName], [LocalName], [CountryCode])
VALUES(515, 'Timor-Leste', NULL, 'TLS')
INSERT INTO [Country] ([Id], [EnglishName], [LocalName], [CountryCode])
VALUES(516, 'Togo', NULL, 'TGO')
INSERT INTO [Country] ([Id], [EnglishName], [LocalName], [CountryCode])
VALUES(517, 'Tonga', NULL, 'TON')
INSERT INTO [Country] ([Id], [EnglishName], [LocalName], [CountryCode])
VALUES(518, 'Trinidad and Tobago', NULL, 'TTO')
INSERT INTO [Country] ([Id], [EnglishName], [LocalName], [CountryCode])
VALUES(519, 'Tunisia', NULL, 'TUN')
INSERT INTO [Country] ([Id], [EnglishName], [LocalName], [CountryCode])
VALUES(520, 'Turkey', NULL, 'TUR')
INSERT INTO [Country] ([Id], [EnglishName], [LocalName], [CountryCode])
VALUES(521, 'Turkmenistan', NULL, 'TKM')
INSERT INTO [Country] ([Id], [EnglishName], [LocalName], [CountryCode])
VALUES(522, 'Turks and Caicos Islands', NULL, 'TCA')
INSERT INTO [Country] ([Id], [EnglishName], [LocalName], [CountryCode])
VALUES(523, 'Tuvalu', NULL, 'TUV')
INSERT INTO [Country] ([Id], [EnglishName], [LocalName], [CountryCode])
VALUES(524, 'Uganda', NULL, 'UGA')
INSERT INTO [Country] ([Id], [EnglishName], [LocalName], [CountryCode])
VALUES(525, 'Ukraine', NULL, 'UKR')
INSERT INTO [Country] ([Id], [EnglishName], [LocalName], [CountryCode])
VALUES(526, 'United Arab Emirates', NULL, 'ARE')
INSERT INTO [Country] ([Id], [EnglishName], [LocalName], [CountryCode])
VALUES(527, 'United Kingdom', NULL, 'GBR')
INSERT INTO [Country] ([Id], [EnglishName], [LocalName], [CountryCode])
VALUES(528, 'United States of America', NULL, 'USA')
INSERT INTO [Country] ([Id], [EnglishName], [LocalName], [CountryCode])
VALUES(529, 'United States Virgin Islands', NULL, 'VIR')
INSERT INTO [Country] ([Id], [EnglishName], [LocalName], [CountryCode])
VALUES(530, 'Uruguay', NULL, 'URY')
INSERT INTO [Country] ([Id], [EnglishName], [LocalName], [CountryCode])
VALUES(531, 'USSR', NULL, 'SUN')
INSERT INTO [Country] ([Id], [EnglishName], [LocalName], [CountryCode])
VALUES(532, 'Uzbekistan', NULL, 'UZB')
INSERT INTO [Country] ([Id], [EnglishName], [LocalName], [CountryCode])
VALUES(533, 'Vanuatu', NULL, 'VUT')
INSERT INTO [Country] ([Id], [EnglishName], [LocalName], [CountryCode])
VALUES(534, 'Vatican City State (Holy See)', NULL, 'VAT')
INSERT INTO [Country] ([Id], [EnglishName], [LocalName], [CountryCode])
VALUES(535, 'Venezuela', NULL, 'VEN')
INSERT INTO [Country] ([Id], [EnglishName], [LocalName], [CountryCode])
VALUES(536, 'Vietnam', NULL, 'VNM')
INSERT INTO [Country] ([Id], [EnglishName], [LocalName], [CountryCode])
VALUES(537, 'Wallis and Futuna Islands', NULL, 'WLF')
INSERT INTO [Country] ([Id], [EnglishName], [LocalName], [CountryCode])
VALUES(538, 'Western Sahara', NULL, 'ESH')
INSERT INTO [Country] ([Id], [EnglishName], [LocalName], [CountryCode])
VALUES(539, 'Yemen', NULL, 'YEM')
INSERT INTO [Country] ([Id], [EnglishName], [LocalName], [CountryCode])
VALUES(540, 'Yugoslavia', NULL, 'YUG')
INSERT INTO [Country] ([Id], [EnglishName], [LocalName], [CountryCode])
VALUES(541, 'Zambia', NULL, 'ZMB')
INSERT INTO [Country] ([Id], [EnglishName], [LocalName], [CountryCode])
VALUES(542, 'Zimbabwe', NULL, 'ZWE')
SET IDENTITY_INSERT [Country] OFF 
ALTER TABLE [Country] CHECK CONSTRAINT ALL
GO



ALTER TABLE [Currency] NOCHECK CONSTRAINT ALL
GO

PRINT 'Begin inserting data in Currency'
ALTER TABLE [Currency] CHECK CONSTRAINT ALL
GO



ALTER TABLE [LocationType] NOCHECK CONSTRAINT ALL
GO

SET IDENTITY_INSERT [LocationType] ON 
PRINT 'Begin inserting data in LocationType'
SET IDENTITY_INSERT [LocationType] OFF 
ALTER TABLE [LocationType] CHECK CONSTRAINT ALL
GO



ALTER TABLE [Region] NOCHECK CONSTRAINT ALL
GO

SET IDENTITY_INSERT [Region] ON 
PRINT 'Begin inserting data in Region'
SET IDENTITY_INSERT [Region] OFF 
ALTER TABLE [Region] CHECK CONSTRAINT ALL
GO



ALTER TABLE [StreetStatus] NOCHECK CONSTRAINT ALL
GO

SET IDENTITY_INSERT [StreetStatus] ON 
PRINT 'Begin inserting data in StreetStatus'
SET IDENTITY_INSERT [StreetStatus] OFF 
ALTER TABLE [StreetStatus] CHECK CONSTRAINT ALL
GO



ALTER TABLE [TimeOfDay] NOCHECK CONSTRAINT ALL
GO

SET IDENTITY_INSERT [TimeOfDay] ON 
PRINT 'Begin inserting data in TimeOfDay'
SET IDENTITY_INSERT [TimeOfDay] OFF 
ALTER TABLE [TimeOfDay] CHECK CONSTRAINT ALL
GO



ALTER TABLE [User] NOCHECK CONSTRAINT ALL
GO

SET IDENTITY_INSERT [User] ON 
PRINT 'Begin inserting data in User'
INSERT INTO [User] ([Id], [Name], [Email], [PasswordHash], [Enabled])
VALUES(28, 'Mohammed Nour', 'mnour@gmail.com', 'C24D0A1968E339C3786751AB16411C2C24CE8A2E',  0)
INSERT INTO [User] ([Id], [Name], [Email], [PasswordHash], [Enabled])
VALUES(29, 'Bashmohandes', 'Bashmohandes@gmail.com', 'C24D0A1968E339C3786751AB16411C2C24CE8A2E',  0)
INSERT INTO [User] ([Id], [Name], [Email], [PasswordHash], [Enabled])
VALUES(30, 'Mohammed Hossam', 'mohammed.hossam@gmail.com', 'C24D0A1968E339C3786751AB16411C2C24CE8A2E',  0)
SET IDENTITY_INSERT [User] OFF 
ALTER TABLE [User] CHECK CONSTRAINT ALL
GO



ALTER TABLE [WeatherStatus] NOCHECK CONSTRAINT ALL
GO

SET IDENTITY_INSERT [WeatherStatus] ON 
PRINT 'Begin inserting data in WeatherStatus'
SET IDENTITY_INSERT [WeatherStatus] OFF 
ALTER TABLE [WeatherStatus] CHECK CONSTRAINT ALL
GO



ALTER TABLE [City] NOCHECK CONSTRAINT ALL
GO

SET IDENTITY_INSERT [City] ON 
PRINT 'Begin inserting data in City'
SET IDENTITY_INSERT [City] OFF 
ALTER TABLE [City] CHECK CONSTRAINT ALL
GO



ALTER TABLE [Comment] NOCHECK CONSTRAINT ALL
GO

PRINT 'Begin inserting data in Comment'
ALTER TABLE [Comment] CHECK CONSTRAINT ALL
GO



ALTER TABLE [Journey] NOCHECK CONSTRAINT ALL
GO

PRINT 'Begin inserting data in Journey'
ALTER TABLE [Journey] CHECK CONSTRAINT ALL
GO



ALTER TABLE [Location] NOCHECK CONSTRAINT ALL
GO

SET IDENTITY_INSERT [Location] ON 
PRINT 'Begin inserting data in Location'
SET IDENTITY_INSERT [Location] OFF 
ALTER TABLE [Location] CHECK CONSTRAINT ALL
GO



ALTER TABLE [Route] NOCHECK CONSTRAINT ALL
GO

SET IDENTITY_INSERT [Route] ON 
PRINT 'Begin inserting data in Route'
SET IDENTITY_INSERT [Route] OFF 
ALTER TABLE [Route] CHECK CONSTRAINT ALL
GO



ALTER TABLE [JourneyComment] NOCHECK CONSTRAINT ALL
GO

PRINT 'Begin inserting data in JourneyComment'
ALTER TABLE [JourneyComment] CHECK CONSTRAINT ALL
GO



